Handling of Nulls

All of TextPipe Pro's processing is done with pure text - TextPipe has no understanding of 'NULL' data values. When DataPipe encounters a NULL column value, it converts it to the text value '<NULL>'. You will see this value in the data preview tab and in the result preview tab.

Similarly, if TextPipe Pro passes back a text value of '<NULL>', DataPipe converts it to the data value of NULL and copies it into the column.

If you wish, you can prevent TextPipe Pro from processing NULLs using one of the following methods:

1. Make sure your SQL query excludes NULL values e.g.
   
     select * from customers where phone_number is not NULL
   
   
2. Use a 'Select lines non-matching' filter, with a pattern of '<NULL>', and then include your search and replaces etc as sub filters of the Select lines filter.
3. You can set a column to NULL by using a 'Delete All' filter followed by a Add Header filter with text of '<NULL>'.